package com.yxuan.springboot.mapper;

import com.yxuan.springboot.model.JobBaseInformation;
import com.yxuan.springboot.model.JobInformation;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 
 * @author zchao
 *    JobInformationMapper层
 * @date 2023-06-05 13:37:33
 */
@Mapper
public interface JobInformationMapper extends BaseMapper<JobInformation> {

    @Select("SELECT work_type FROM `job_information` group by work_type")
    List<JobInformation> getTypeByGroup();

    @Select("SELECT id,name FROM `job_information` where work_type = #{workType}")
    List<JobBaseInformation> getParamByWorkType(@Param("workType") String workType);
}
